A Make2D-DB II DATABASE: version 2.50, built 18-Jul-2006

Dumped on 2006-07-18

The Make2D-DB II Tool

Index of database structure for schema: log

analyte
analytepreparation
analyzable
author
authorgroup
authorparent
biologicalprocess
biosource
biosourceinformation
biosourcepreparation
book
cellularcomponent
citer
commententry2d
commententryfreetext
commententryparent
commenttopic
contact
dynamicremotemake2ddbinterface
entry
entrygelimage
entrygelmaster
entrygene
entrytheoreticalpimw
entryversion2d
entryversiongeneral
entryversionparent
entryxrefdb
entryxrefdbdynamic
entryxrefdbparent
enzymenomenclature
externalmainxrefdata
gel
gelcomputabledynamic
geldynamic
gelimage
gelinformatics
gelpreparation
geltissuesp
genename
geneontologyparent
geneorderedlocus
geneorf
generaltopicdefinition
generaltopicentrydata
genesynonym
journal
make2ddbtool
mappingtopicdefinition
molecularfunction
organism
project
reference
referencedentry
referencedgel
referencedobjectparent
referencedproject
referencedsample
referencelocationbook
referencelocationjournal
referencelocationother
referencelocationparent
referencelocationpatent
referencelocationsubmission
referencelocationthesis
referencelocationunpubobservations
referencetype
referencework
release
sample
samplepreparation
secondaryac
spot
spotdataaacid
spotdataother
spotdataparent
spotdatapeptmassf
spotdatatandemms
spotentry
spotentrygeneraltopic
spotentrymappingtopic
spotentrytopicparent
spotidentificationaacid
spotidentificationother
spotidentificationparent
spotidentificationpeptmassf
spotidentificationtandemms
spotidentificationtandemmssubset
study
studygroup
tissue
tissuesp
tissuespaliase
tissuesptissuemapping
xrefdb
xrefdbdynamic
xrefdbparent

Table: analyte

analyte Structure
Name	Type	Description
analyteid	integer
sampleid	integer
analytepreparationid	integer
description	text
analyteparentid	integer
fromanalyzablesource	integer
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

analyte Constraints
Name	Constraint
analyte_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
analyte_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: analytepreparation

analytepreparation Structure
Name	Type	Description
analytepreparationid	integer
preparationprotocol	text
uri	character varying(4096)
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

analytepreparation Constraints
Name	Constraint
analytepreparation_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
analytepreparation_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: analyzable

analyzable Structure
Name	Type	Description
analyzableid	integer
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

analyzable Constraints
Name	Constraint
analyzable_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
analyzable_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: author

author Structure
Name	Type	Description
author	character varying(1024)
article	integer
authorpriority	smallint
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

author Constraints
Name	Constraint
author_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
author_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: authorgroup

authorgroup Structure
Name	Type	Description
author	character varying(1024)
article	integer
authorpriority	smallint
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

authorgroup Constraints
Name	Constraint
authorgroup_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
authorgroup_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: authorparent

authorparent Structure
Name	Type	Description
author	character varying(1024)
article	integer
authorpriority	smallint
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

authorparent Constraints
Name	Constraint
authorparent_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
authorparent_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: biologicalprocess

biologicalprocess Structure
Name	Type	Description
ac	character varying(32)
goid	character varying(32)
goname	character varying(256)
gosynoymsnames	character varying(1024)
godefinition	character varying(1024)
lastupdate	timestamp without time zone
mappedenzymeclassification	character varying(16)
mappedtransportclassification	character varying(16)
goparents	character varying(32)[]
gochildren	character varying(32)[]
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

biologicalprocess Constraints
Name	Constraint
biologicalprocess_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
biologicalprocess_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: biosource

biosource Structure
Name	Type	Description
biosourceid	integer
studygroupid	integer
biosourceinformationid	integer
biosourcepreparationid	integer
description	text
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

biosource Constraints
Name	Constraint
biosource_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
biosource_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: biosourceinformation

biosourceinformation Structure
Name	Type	Description
biosourceinformationid	integer
organismid	integer
organismstrain	character varying(256)
straindetailsdescription	text
individualscount	character varying(256)
genotype	character varying(16)
developmentalstage	character varying(256)
anatomy	character varying(256)
tissueid	integer
cell	character varying(256)
cellline	character varying(256)
measuredproperties	text
environmet	character varying(256)
treatment	text
phenotype	text
behaviour	text
pathology	text
provider	character varying(256)
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

biosourceinformation Constraints
Name	Constraint
biosourceinformation_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
biosourceinformation_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: biosourcepreparation

biosourcepreparation Structure
Name	Type	Description
biosourcepreparationid	integer
preparationprotocol	text
uri	character varying(4096)
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

biosourcepreparation Constraints
Name	Constraint
biosourcepreparation_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
biosourcepreparation_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: book

book Structure
Name	Type	Description
bookid	integer
booktitle	character varying(256)
editors	character varying(256)
publisher	character varying(128)
city	character varying(64)
year	smallint
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

book Constraints
Name	Constraint
book_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
book_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: cellularcomponent

cellularcomponent Structure
Name	Type	Description
ac	character varying(32)
goid	character varying(32)
goname	character varying(256)
gosynoymsnames	character varying(1024)
godefinition	character varying(1024)
lastupdate	timestamp without time zone
mappedenzymeclassification	character varying(16)
mappedtransportclassification	character varying(16)
goparents	character varying(32)[]
gochildren	character varying(32)[]
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

cellularcomponent Constraints
Name	Constraint
cellularcomponent_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
cellularcomponent_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: citer

citer Structure
Name	Type	Description
author	character varying(1024)
article	integer
authorpriority	smallint
unpublished	boolean
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

citer Constraints
Name	Constraint
citer_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
citer_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: commententry2d

commententry2d Structure
Name	Type	Description
ac	character varying(32)
commenttopicid	integer
commentfreetext	text
geldimension	smallint
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

commententry2d Constraints
Name	Constraint
commententry2d_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
commententry2d_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: commententryfreetext

commententryfreetext Structure
Name	Type	Description
ac	character varying(32)
commenttopicid	integer
commentfreetext	text
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

commententryfreetext Constraints
Name	Constraint
commententryfreetext_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
commententryfreetext_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: commententryparent

commententryparent Structure
Name	Type	Description
ac	character varying(32)
commenttopicid	integer
commentfreetext	text
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

commententryparent Constraints
Name	Constraint
commententryparent_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
commententryparent_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: commenttopic

commenttopic Structure
Name	Type	Description
commenttopicid	integer
commenttopicname	character varying(64)
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

commenttopic Constraints
Name	Constraint
commenttopic_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
commenttopic_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: contact

contact Structure
Name	Type	Description
contactid	integer
name	character varying(256)
email	character varying(256)
institution	character varying(256)
address	text
remark	text
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

contact Constraints
Name	Constraint
contact_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
contact_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: dynamicremotemake2ddbinterface

dynamicremotemake2ddbinterface Structure
Name	Type	Description
interfaceid	integer
interfaceuri	text
dbnumber	integer
dbname	character varying(128)
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

dynamicremotemake2ddbinterface Constraints
Name	Constraint
dynamicremotemake2ddbinterface_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
dynamicremotemake2ddbinterface_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: entry

entry Structure
Name	Type	Description
ac	character varying(32)
id	character varying(32)
entryclass	character varying(32)
identmethod	character varying(16)
description	text
releasecreation	integer
subreleasecreation	integer
genenames	character varying(1024)
keywords	character varying(1024)
organismid	integer
organismstrain	character varying(256)
entrychecksum	character(16)
showflag	boolean
showflagswitch	boolean
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

entry Constraints
Name	Constraint
entry_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
entry_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: entrygelimage

entrygelimage Structure
Name	Type	Description
ac	character varying(32)
gelid	integer
showflag	boolean
showflagswitch	boolean
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

entrygelimage Constraints
Name	Constraint
entrygelimage_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
entrygelimage_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: entrygelmaster

entrygelmaster Structure
Name	Type	Description
ac	character varying(32)
gelid	integer
showflag	boolean
showflagswitch	boolean
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

entrygelmaster Constraints
Name	Constraint
entrygelmaster_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
entrygelmaster_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: entrygene

entrygene Structure
Name	Type	Description
ac	character varying(32)
geneid	integer
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

entrygene Constraints
Name	Constraint
entrygene_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
entrygene_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: entrytheoreticalpimw

entrytheoreticalpimw Structure
Name	Type	Description
ac	character varying(32)
modifiedproteindescription	text
theoreticalpi	numeric(4,2)
theoreticalmw	integer
algorithmoriginandversion	text
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

entrytheoreticalpimw Constraints
Name	Constraint
entrytheoreticalpimw_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
entrytheoreticalpimw_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: entryversion2d

entryversion2d Structure
Name	Type	Description
ac	character varying(32)
version	integer
versiondate	date
annotationchanged	boolean
annotationchecksum	character(16)
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

entryversion2d Constraints
Name	Constraint
entryversion2d_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
entryversion2d_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: entryversiongeneral

entryversiongeneral Structure
Name	Type	Description
ac	character varying(32)
version	integer
versiondate	date
annotationchanged	boolean
annotationchecksum	character(16)
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

entryversiongeneral Constraints
Name	Constraint
entryversiongeneral_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
entryversiongeneral_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: entryversionparent

entryversionparent Structure
Name	Type	Description
ac	character varying(32)
version	integer
versiondate	date
annotationchanged	boolean
annotationchecksum	character(16)
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

entryversionparent Constraints
Name	Constraint
entryversionparent_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
entryversionparent_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: entryxrefdb

entryxrefdb Structure
Name	Type	Description
ac	character varying(32)
xrefdbcode	integer
xrefprimaryidentifier	character varying(32)
xrefsecondaryidentifier	character varying(1024)
xreftertiaryidentifier	character varying(1024)
xrefotheridentifiers	character varying(1024)
activated	boolean
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

entryxrefdb Constraints
Name	Constraint
entryxrefdb_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
entryxrefdb_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: entryxrefdbdynamic

entryxrefdbdynamic Structure
Name	Type	Description
ac	character varying(32)
xrefdbcode	integer
xrefprimaryidentifier	character varying(32)
xrefsecondaryidentifier	character varying(1024)
xreftertiaryidentifier	character varying(1024)
xrefotheridentifiers	character varying(1024)
activated	boolean
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

entryxrefdbdynamic Constraints
Name	Constraint
entryxrefdbdynamic_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
entryxrefdbdynamic_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: entryxrefdbparent

entryxrefdbparent Structure
Name	Type	Description
ac	character varying(32)
xrefdbcode	integer
xrefprimaryidentifier	character varying(32)
xrefsecondaryidentifier	character varying(1024)
xreftertiaryidentifier	character varying(1024)
xrefotheridentifiers	character varying(1024)
activated	boolean
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

entryxrefdbparent Constraints
Name	Constraint
entryxrefdbparent_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
entryxrefdbparent_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: enzymenomenclature

enzymenomenclature Structure
Name	Type	Description
enzymecode	character varying(16)
ac	character varying(32)
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

enzymenomenclature Constraints
Name	Constraint
enzymenomenclature_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
enzymenomenclature_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: externalmainxrefdata

externalmainxrefdata Structure
Name	Type	Description
ac	character varying(32)
uniprotextractiondate	date
uniprotac	character varying(32)
uniprotsecondaryac	character varying(32)[]
uniprotid	character varying(32)
uniprotversion	numeric(5,2)
uniprotentryincorporateddate	date
uniprotsequpdate	date
uniprotsequpversion	smallint
uniprotentryupdate	date
uniprotentryupversion	smallint
uniprotdescription	text
uniprotenzymecode	character varying(16)
uniprotgenenames	character varying(1024)
uniprotorganelleplasmid	character varying(256)
uniprotcategorykeywords	character varying(1024)
uniprotxrefs	character varying(1024)[]
sportrembl	boolean
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

externalmainxrefdata Constraints
Name	Constraint
externalmainxrefdata_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
externalmainxrefdata_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: gel

gel Structure
Name	Type	Description
gelid	integer
melaniegeneratedid	character varying(64)
shortname	character varying(32)
fullname	character varying(256)
dimension	smallint
startmw	bigint
endmw	bigint
startpi	numeric(4,2)
endpi	numeric(4,2)
organismid	integer
organismstrain	character varying(256)
gelparentid	integer
gelpreparationid	integer
gelinformaticsid	integer
biosourceinformationid	integer
showflag	boolean
showflagswitch	boolean
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

gel Constraints
Name	Constraint
gel_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
gel_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: gelcomputabledynamic

gelcomputabledynamic Structure
Name	Type	Description
databasename	character varying(64)
gelshortname	character varying(32)
gelfullname	character varying(256)
organismspecies	text
taxonomycode	integer
gelcomputableurl	text
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

gelcomputabledynamic Constraints
Name	Constraint
gelcomputabledynamic_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
gelcomputabledynamic_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: geldynamic

geldynamic Structure
Name	Type	Description
databasename	character varying(64)
gelshortname	character varying(32)
gelfullname	character varying(256)
organismspecies	text
taxonomycode	integer
tissuename	character varying(256)
tissuespname	character varying(256)
gelurl	text
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

geldynamic Constraints
Name	Constraint
geldynamic_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
geldynamic_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: gelimage

gelimage Structure
Name	Type	Description
gelid	integer
masterimage	oid
imageurl	text
imagepath	text
imagetype	character varying(3)
smallimageurl	text
smallimagepath	text
smallimagetype	character varying(3)
xpixelsize	smallint
ypixelsize	smallint
xratio	numeric(6,4)
yratio	numeric(6,4)
xpixelshift	smallint
ypixelshift	smallint
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

gelimage Constraints
Name	Constraint
gelimage_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
gelimage_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: gelinformatics

gelinformatics Structure
Name	Type	Description
gelinformaticsid	integer
uri	character varying(4096)
informaticsdocument	text
informaticsdescription	text
soft	text
contactid	integer
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

gelinformatics Constraints
Name	Constraint
gelinformatics_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
gelinformatics_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: gelpreparation

gelpreparation Structure
Name	Type	Description
gelpreparationid	integer
analyteid	integer
uri	character varying(4096)
preparationdocument	text
preparationdescription	text
contactid	integer
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

gelpreparation Constraints
Name	Constraint
gelpreparation_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
gelpreparation_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: geltissuesp

geltissuesp Structure
Name	Type	Description
gelid	integer
tissuespname	character varying(256)
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

geltissuesp Constraints
Name	Constraint
geltissuesp_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
geltissuesp_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: genename

genename Structure
Name	Type	Description
geneid	integer
genename	character varying(16)
organismid	integer
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

genename Constraints
Name	Constraint
genename_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
genename_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: geneontologyparent

geneontologyparent Structure
Name	Type	Description
ac	character varying(32)
goid	character varying(32)
goname	character varying(256)
gosynoymsnames	character varying(1024)
godefinition	character varying(1024)
lastupdate	timestamp without time zone
mappedenzymeclassification	character varying(16)
mappedtransportclassification	character varying(16)
goparents	character varying(32)[]
gochildren	character varying(32)[]
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

geneontologyparent Constraints
Name	Constraint
geneontologyparent_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
geneontologyparent_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: geneorderedlocus

geneorderedlocus Structure
Name	Type	Description
geneid	integer
orderedlocusname	character varying(32)
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

geneorderedlocus Constraints
Name	Constraint
geneorderedlocus_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
geneorderedlocus_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: geneorf

geneorf Structure
Name	Type	Description
geneid	integer
orfname	character varying(32)
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

geneorf Constraints
Name	Constraint
geneorf_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
geneorf_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: generaltopicdefinition

generaltopicdefinition Structure
Name	Type	Description
generaltopicid	integer
topicname	character varying(64)
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

generaltopicdefinition Constraints
Name	Constraint
generaltopicdefinition_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
generaltopicdefinition_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: generaltopicentrydata

generaltopicentrydata Structure
Name	Type	Description
topicdataid	integer
generaltopicid	integer
topicdatatext	text
allreferences	integer[]
ambiguousreference	boolean
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

generaltopicentrydata Constraints
Name	Constraint
generaltopicentrydata_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
generaltopicentrydata_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: genesynonym

genesynonym Structure
Name	Type	Description
geneid	integer
synonym	character varying(16)
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

genesynonym Constraints
Name	Constraint
genesynonym_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
genesynonym_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: journal

journal Structure
Name	Type	Description
journalid	integer
journalname	character varying(256)
url	text
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

journal Constraints
Name	Constraint
journal_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
journal_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: make2ddbtool

make2ddbtool Structure
Name	Type	Description
version	numeric(4,2)
subversion	character varying(64)
versiondate	date
postgresqlversion	text
action	text
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

make2ddbtool Constraints
Name	Constraint
make2ddbtool_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
make2ddbtool_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: mappingtopicdefinition

mappingtopicdefinition Structure
Name	Type	Description
mappingtechnique	character varying(8)
techniquedescription	character varying(256)
containingregexp	text
excludingregexp	text
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

mappingtopicdefinition Constraints
Name	Constraint
mappingtopicdefinition_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
mappingtopicdefinition_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: molecularfunction

molecularfunction Structure
Name	Type	Description
ac	character varying(32)
goid	character varying(32)
goname	character varying(256)
gosynoymsnames	character varying(1024)
godefinition	character varying(1024)
lastupdate	timestamp without time zone
mappedenzymeclassification	character varying(16)
mappedtransportclassification	character varying(16)
goparents	character varying(32)[]
gochildren	character varying(32)[]
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

molecularfunction Constraints
Name	Constraint
molecularfunction_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
molecularfunction_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: organism

organism Structure
Name	Type	Description
organismid	integer
organismspecies	text
organismclassification	text
taxonomyxrefdbcode	integer
taxonomycode	integer
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

organism Constraints
Name	Constraint
organism_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
organism_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: project

project Structure
Name	Type	Description
projectid	integer
description	text
uri	character varying(4096)
contactid	integer
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

project Constraints
Name	Constraint
project_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
project_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: reference

reference Structure
Name	Type	Description
referenceid	integer
referenceworkid	integer
referencetitle	text
referencetypeid	integer
referencechecksum	character(16)
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

reference Constraints
Name	Constraint
reference_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
reference_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: referencedentry

referencedentry Structure
Name	Type	Description
referenceid	integer
ac	character varying(32)
rndisplayedvalue	smallint
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

referencedentry Constraints
Name	Constraint
referencedentry_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
referencedentry_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: referencedgel

referencedgel Structure
Name	Type	Description
referenceid	integer
gelid	integer
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

referencedgel Constraints
Name	Constraint
referencedgel_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
referencedgel_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: referencedobjectparent

referencedobjectparent Structure
Name	Type	Description
referenceid	integer
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

referencedobjectparent Constraints
Name	Constraint
referencedobjectparent_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
referencedobjectparent_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: referencedproject

referencedproject Structure
Name	Type	Description
referenceid	integer
projectid	integer
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

referencedproject Constraints
Name	Constraint
referencedproject_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
referencedproject_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: referencedsample

referencedsample Structure
Name	Type	Description
referenceid	integer
sampleid	integer
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

referencedsample Constraints
Name	Constraint
referencedsample_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
referencedsample_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: referencelocationbook

referencelocationbook Structure
Name	Type	Description
referenceid	integer
bookid	integer
volume	smallint
pagefirst	integer
pagelast	integer
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

referencelocationbook Constraints
Name	Constraint
referencelocationbook_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
referencelocationbook_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: referencelocationjournal

referencelocationjournal Structure
Name	Type	Description
referenceid	integer
journalid	integer
volume	smallint
subvolume	smallint
pagefirst	integer
pagelast	integer
year	smallint
crossreferences	character varying(128)[]
unpublished	boolean
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

referencelocationjournal Constraints
Name	Constraint
referencelocationjournal_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
referencelocationjournal_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: referencelocationother

referencelocationother Structure
Name	Type	Description
referenceid	integer
text	text
personalcomment	character varying(256)
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

referencelocationother Constraints
Name	Constraint
referencelocationother_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
referencelocationother_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: referencelocationparent

referencelocationparent Structure
Name	Type	Description
referenceid	integer
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

referencelocationparent Constraints
Name	Constraint
referencelocationparent_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
referencelocationparent_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: referencelocationpatent

referencelocationpatent Structure
Name	Type	Description
referenceid	integer
patent_publication_number	character varying(16)
date	date
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

referencelocationpatent Constraints
Name	Constraint
referencelocationpatent_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
referencelocationpatent_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: referencelocationsubmission

referencelocationsubmission Structure
Name	Type	Description
referenceid	integer
month	smallint
year	smallint
xrefdbcode	integer
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

referencelocationsubmission Constraints
Name	Constraint
referencelocationsubmission_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
referencelocationsubmission_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: referencelocationthesis

referencelocationthesis Structure
Name	Type	Description
referenceid	integer
year	smallint
institution	character varying(128)
country	character varying(64)
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

referencelocationthesis Constraints
Name	Constraint
referencelocationthesis_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
referencelocationthesis_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: referencelocationunpubobservations

referencelocationunpubobservations Structure
Name	Type	Description
referenceid	integer
month	smallint
year	smallint
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

referencelocationunpubobservations Constraints
Name	Constraint
referencelocationunpubobservations_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
referencelocationunpubobservations_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: referencetype

referencetype Structure
Name	Type	Description
referencetypeid	integer
referencetype	character varying(32)
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

referencetype Constraints
Name	Constraint
referencetype_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
referencetype_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: referencework

referencework Structure
Name	Type	Description
referenceworkid	integer
referenceworkdescription	character varying(64)
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

referencework Constraints
Name	Constraint
referencework_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
referencework_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: release

release Structure
Name	Type	Description
releasenum	integer
subrelease	smallint
releasedate	date
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

release Constraints
Name	Constraint
release_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
release_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: sample

sample Structure
Name	Type	Description
sampleid	integer
biosourceid	integer
uri	character varying(4096)
samplepreparationid	integer
description	text
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

sample Constraints
Name	Constraint
sample_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
sample_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: samplepreparation

samplepreparation Structure
Name	Type	Description
samplepreparationid	integer
uri	character varying(4096)
samplepreparationdocument	text
samplepreparationprotocol	text
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

samplepreparation Constraints
Name	Constraint
samplepreparation_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
samplepreparation_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: secondaryac

secondaryac Structure
Name	Type	Description
secondaryac	character varying(32)
ac	character varying(32)
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

secondaryac Constraints
Name	Constraint
secondaryac_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
secondaryac_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: spot

spot Structure
Name	Type	Description
spotid	character varying(16)
gelid	integer
mw	integer
pi	numeric(4,2)
xcoordinate	integer
ycoordinate	integer
odrelative	real
volumerelative	real
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

spot Constraints
Name	Constraint
spot_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
spot_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: spotdataaacid

spotdataaacid Structure
Name	Type	Description
dataexpid	integer
humanidentifier	character varying(256)
spotid	character varying(16)
gelid	integer
referenceid	integer
contactid	integer
uri	character varying(4096)
datadocument	text
experimentdescription	text
experimentdate	date
appreciation	smallint
datadisplayer	text
showflag	boolean
showflagswitch	boolean
aminoacidlist	text
relateddata	text
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

spotdataaacid Constraints
Name	Constraint
spotdataaacid_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
spotdataaacid_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: spotdataother

spotdataother Structure
Name	Type	Description
dataexpid	integer
humanidentifier	character varying(256)
spotid	character varying(16)
gelid	integer
referenceid	integer
contactid	integer
uri	character varying(4096)
datadocument	text
experimentdescription	text
experimentdate	date
appreciation	smallint
datadisplayer	text
showflag	boolean
showflagswitch	boolean
results	text
relateddata	text
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

spotdataother Constraints
Name	Constraint
spotdataother_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
spotdataother_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: spotdataparent

spotdataparent Structure
Name	Type	Description
dataexpid	integer
humanidentifier	character varying(256)
spotid	character varying(16)
gelid	integer
referenceid	integer
contactid	integer
uri	character varying(4096)
datadocument	text
experimentdescription	text
experimentdate	date
appreciation	smallint
datadisplayer	text
showflag	boolean
showflagswitch	boolean
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

spotdataparent Constraints
Name	Constraint
spotdataparent_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
spotdataparent_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: spotdatapeptmassf

spotdatapeptmassf Structure
Name	Type	Description
dataexpid	integer
humanidentifier	character varying(256)
spotid	character varying(16)
gelid	integer
referenceid	integer
contactid	integer
uri	character varying(4096)
datadocument	text
experimentdescription	text
experimentdate	date
appreciation	smallint
datadisplayer	text
showflag	boolean
showflagswitch	boolean
peptidemasses	double precision[]
enzyme	character varying(32)
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

spotdatapeptmassf Constraints
Name	Constraint
spotdatapeptmassf_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
spotdatapeptmassf_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: spotdatatandemms

spotdatatandemms Structure
Name	Type	Description
dataexpid	integer
humanidentifier	character varying(256)
spotid	character varying(16)
gelid	integer
referenceid	integer
contactid	integer
uri	character varying(4096)
datadocument	text
experimentdescription	text
experimentdate	date
appreciation	smallint
datadisplayer	text
showflag	boolean
showflagswitch	boolean
parentmass	double precision
parentcharge	smallint
ionmasses	double precision[]
relateddata	text
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

spotdatatandemms Constraints
Name	Constraint
spotdatatandemms_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
spotdatatandemms_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: spotentry

spotentry Structure
Name	Type	Description
spotid	character varying(16)
gelid	integer
ac	character varying(32)
fragment	boolean
showflag	boolean
showflagswitch	boolean
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

spotentry Constraints
Name	Constraint
spotentry_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
spotentry_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: spotentrygeneraltopic

spotentrygeneraltopic Structure
Name	Type	Description
topicdataid	integer
spotid	character varying(16)
gelid	integer
ac	character varying(32)
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

spotentrygeneraltopic Constraints
Name	Constraint
spotentrygeneraltopic_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
spotentrygeneraltopic_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: spotentrymappingtopic

spotentrymappingtopic Structure
Name	Type	Description
topicdataid	integer
spotid	character varying(16)
gelid	integer
ac	character varying(32)
mappingtechnique	character varying(8)[]
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

spotentrymappingtopic Constraints
Name	Constraint
spotentrymappingtopic_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
spotentrymappingtopic_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: spotentrytopicparent

spotentrytopicparent Structure
Name	Type	Description
topicdataid	integer
spotid	character varying(16)
gelid	integer
ac	character varying(32)
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

spotentrytopicparent Constraints
Name	Constraint
spotentrytopicparent_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
spotentrytopicparent_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: spotidentificationaacid

spotidentificationaacid Structure
Name	Type	Description
identificationid	integer
humanidentifier	character varying(256)
hassubset	boolean
dataexpid	integer
spotid	character varying(16)
gelid	integer
ac	character varying(32)
isoform	text
version	integer
contactid	integer
uri	character varying(4096)
identificationdocument	text
identificationdescription	text
allexperimentdata	boolean
appreciation	numeric(2,1)
datadisplayer	text
showflag	boolean
showflagswitch	boolean
aminoacidlist	text
relateddata	text
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

spotidentificationaacid Constraints
Name	Constraint
spotidentificationaacid_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
spotidentificationaacid_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: spotidentificationother

spotidentificationother Structure
Name	Type	Description
identificationid	integer
humanidentifier	character varying(256)
hassubset	boolean
dataexpid	integer
spotid	character varying(16)
gelid	integer
ac	character varying(32)
isoform	text
version	integer
contactid	integer
uri	character varying(4096)
identificationdocument	text
identificationdescription	text
allexperimentdata	boolean
appreciation	numeric(2,1)
datadisplayer	text
showflag	boolean
showflagswitch	boolean
results	text
relateddata	text
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

spotidentificationother Constraints
Name	Constraint
spotidentificationother_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
spotidentificationother_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: spotidentificationparent

spotidentificationparent Structure
Name	Type	Description
identificationid	integer
humanidentifier	character varying(256)
hassubset	boolean
dataexpid	integer
spotid	character varying(16)
gelid	integer
ac	character varying(32)
isoform	text
version	integer
contactid	integer
uri	character varying(4096)
identificationdocument	text
identificationdescription	text
allexperimentdata	boolean
appreciation	numeric(2,1)
datadisplayer	text
showflag	boolean
showflagswitch	boolean
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

spotidentificationparent Constraints
Name	Constraint
spotidentificationparent_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
spotidentificationparent_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: spotidentificationpeptmassf

spotidentificationpeptmassf Structure
Name	Type	Description
identificationid	integer
humanidentifier	character varying(256)
hassubset	boolean
dataexpid	integer
spotid	character varying(16)
gelid	integer
ac	character varying(32)
isoform	text
version	integer
contactid	integer
uri	character varying(4096)
identificationdocument	text
identificationdescription	text
allexperimentdata	boolean
appreciation	numeric(2,1)
datadisplayer	text
showflag	boolean
showflagswitch	boolean
peptidemasses	double precision[]
relateddata	text
xxac	character varying(32)
xxdirectory	character varying(256)
xxfile	character varying(64)
xxprogversion	character varying(64)
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

spotidentificationpeptmassf Constraints
Name	Constraint
spotidentificationpeptmassf_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
spotidentificationpeptmassf_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: spotidentificationtandemms

spotidentificationtandemms Structure
Name	Type	Description
identificationid	integer
humanidentifier	character varying(256)
hassubset	boolean
dataexpid	integer
spotid	character varying(16)
gelid	integer
ac	character varying(32)
isoform	text
version	integer
contactid	integer
uri	character varying(4096)
identificationdocument	text
identificationdescription	text
allexperimentdata	boolean
appreciation	numeric(2,1)
datadisplayer	text
showflag	boolean
showflagswitch	boolean
ionmasses	double precision[]
relateddata	text
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

spotidentificationtandemms Constraints
Name	Constraint
spotidentificationtandemms_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
spotidentificationtandemms_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: spotidentificationtandemmssubset

spotidentificationtandemmssubset Structure
Name	Type	Description
identificationid	integer
ionmasses	double precision[]
identifiedpeptidesequence	text
sequencestartposition	smallint
sequenceendposition	smallint
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

spotidentificationtandemmssubset Constraints
Name	Constraint
spotidentificationtandemmssubset_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
spotidentificationtandemmssubset_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: study

study Structure
Name	Type	Description
studyid	integer
projectid	integer
description	text
contactid	integer
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

study Constraints
Name	Constraint
study_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
study_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: studygroup

studygroup Structure
Name	Type	Description
studygroupid	integer
studyid	integer
description	text
biosourceinformationid	integer
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

studygroup Constraints
Name	Constraint
studygroup_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
studygroup_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: tissue

tissue Structure
Name	Type	Description
tissueid	integer
tissuename	character varying(256)
tissueparentid	integer
tissuecomment	character varying(1024)
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

tissue Constraints
Name	Constraint
tissue_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
tissue_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: tissuesp

tissuesp Structure
Name	Type	Description
tissuespname	character varying(256)
tissuespdisplayedname	character varying(256)
tissueindate	date
tissuecomment	character varying(1024)
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

tissuesp Constraints
Name	Constraint
tissuesp_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
tissuesp_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: tissuespaliase

tissuespaliase Structure
Name	Type	Description
tissuespname	character varying(256)
alias	character varying(256)
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

tissuespaliase Constraints
Name	Constraint
tissuespaliase_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
tissuespaliase_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: tissuesptissuemapping

tissuesptissuemapping Structure
Name	Type	Description
tissuespname	character varying(256)
tissueid	integer
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

tissuesptissuemapping Constraints
Name	Constraint
tissuesptissuemapping_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
tissuesptissuemapping_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: xrefdb

xrefdb Structure
Name	Type	Description
xrefdbcode	integer
xrefdbname	character varying(64)
description	text
url	text
displayerurl	text
displayerparameters	text
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

xrefdb Constraints
Name	Constraint
xrefdb_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
xrefdb_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: xrefdbdynamic

xrefdbdynamic Structure
Name	Type	Description
xrefdbcode	integer
xrefdbname	character varying(64)
description	text
url	text
displayerurl	text
displayerparameters	text
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

xrefdbdynamic Constraints
Name	Constraint
xrefdbdynamic_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
xrefdbdynamic_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Table: xrefdbparent

xrefdbparent Structure
Name	Type	Description
xrefdbcode	integer
xrefdbname	character varying(64)
description	text
url	text
displayerurl	text
displayerparameters	text
userstamp	character varying(128)
modificationdate	timestamp without time zone	DEFAULT now()
updatedordeleted	character(1)
usermodifiername	character varying(128)

xrefdbparent Constraints
Name	Constraint
xrefdbparent_modificationdate_check	CHECK ((modificationdate IS NOT NULL))
xrefdbparent_updatedordeleted_check	CHECK (((updatedordeleted = 'U'::bpchar) OR (updatedordeleted = 'D'::bpchar)))

Index - Schema log

Generated by PostgreSQL Autodoc

W3C HTML 4.01 Strict